File manager

File manager - Edit - /home/autoph/public_html/projects/Rating-AutoHub/public/css/autoph.zip

Back
PK��Z<�g�ry��ry��PRF_ACTIVE_PO.phpnu��[��<?php include 'core/init.php'; protected_page(); $uniqueRefID = $user_data['u_id']; //echo $uniqueRefID; $prfDate = date_create() ->format("Y-m-d"); $prtTime =Explode(":", date('H:i:s')); $txDate = explode("-",$prfDate); $refYear = $txDate[0]; $refMonth = $txDate[1]; $refMinute = $prtTime[1]; $refSecond = $prtTime[2]; //$NewRefCode = $refYear.''.$refMonth.''.$refMinute.''.$refSecond.''.$uniqueRefID; ?> <!DOCTYPE html> <html lang="en"> <head> <link rel="stylesheet" type="text/css" href="css/bootstrap.css"/> <link rel="stylesheet" type="text/css" href="css/jquery-ui.css"/> <meta charset="UTF-8" name="viewport" content="width=device-width, initial-scale=1"/> </head> <body> <div id='topMessage' style='border-radius:5px;z-index:9999999999999;position:absolute; top:10px;left:10px;width:400px;height:120px;background:yellow;border:solid 2px #efdd01 ;display:none;padding:15px;font-family:Yu Gothic Light;font-size:1vw;color:black'> PO Validation LINK has been sent to all officers using their register mobile and e-mail address. </div> <div class='NewPRFHeader'> <p class='PRFBodyTitle'>📝  OPEN PURCHASE ORDER</p> </div> <!--########################## MAIN TABLE WINDOW ############################################--> <!--########################################################################################################--> <div class='NewPRFBody' > <div class='NewPRFBodyMenu'> <div class='searchDIVA'> <!--<b class='BodyTopMenu' id='LoadNewPRFForm' onclick='showActionSlipForm()'>➕ New Purchase </b> <b class='BodyTopMenu' onclick="javascript:showPOForm();">📑 Create New PO </b> <b class='BodyTopMenu'>📠 Print </b> <b class='BodyTopMenu' onclick="javascript:getInfoCode(this);">⬇ Export</b> --> </div> <div class='searchDIVB'> <input type='hidden' id='userActiveID' value='<?php echo $uniqueRefID;?>'> <input type='text' id='SearchCanvass' placeholder='Search Record.' class='textSearch' style='width:70%;margin:0px;border:1px solid lightgray;'> <button id='goSearchCanvass' class='searchButton' style='width:25%'> 🔍       Search</button> </div> </div> <div id='mainTable' class='PRFTableBody'> <div style='width:100%;height:33px;background:white'> <table> <thead> <th style='width:5%'>REC.#</th> <th style='width:10%'>PO NUMBER</th> <th style='width:8%'>DATE POSTED</th> <th style='width:10%'>COMPANY</th> <th style='width:10%'>DEALER</th> <th style='width:22%'>VENDOR</th> <th style='width:5%'>TERMS</th> <th style='width:10%'>STATUS</th> <th style='width:15%'>REMARKS</th> <th style='width:5%'>...</th> </thead> </table> </div> <div class='PRFTableItems' id='mainTableSub'> <table> <?php //######################################PAGINATION####################################################### //######################################PAGINATION####################################################### //$totalRows = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_purchase_order` WHERE `po_status`=1 "),0); //$noOfRecordPerPage = mysql_result(mysql_query("SELECT `page_count` FROM `asa_versioning_db` WHERE 1"),0); //$myPageCount = ceil($totalRows / $noOfRecordPerPage); //$offSet = 0;//($myPageCount-1) * $noOfRecordPerPage; //echo "<input type='hidden' id='MyPageCount' value='".$myPageCount."'>"; //echo "<input type='hidden' id='MyRowCount' value='".$totalRows."'>"; //echo "<input type='hidden' id='myOffSet' value='".$offSet."'>"; //echo "<input type='hidden' id='recordPerPage' value='".$noOfRecordPerPage."'>"; //####################################################################################################### //####################################################################################################### //SELECT COUNT(id) FROM `prf_purchase_order` WHERE `po_status`= 1 //$getItemHdr = mysql_query("SELECT * FROM `prf_purchase_order` WHERE `po_status`= 1 \|\| `po_status`= 0 ORDER BY `id` DESC LIMIT $offSet, $noOfRecordPerPage "); $getItemHdr = mysql_query("SELECT * FROM `prf_purchase_order` WHERE `po_status`= 1 \|\| `po_status`= 0 ORDER BY `id` DESC "); while($row=mysql_fetch_array($getItemHdr)){ $vendorID = $row['vendor_id']; $vendorName = mysql_result(mysql_query("SELECT `sup_name` FROM `prf_suppliers` WHERE `id`='$vendorID'"),0); $reqCompID=$row['comp_id']; $reqDealID=$row['dealer_id']; $reqCompName = mysql_result(mysql_query("SELECT `comp_code` FROM vts_company WHERE comp_id='$reqCompID'"),0); $reqDealName = mysql_result(mysql_query("SELECT `deal_code` FROM vts_dealerships WHERE deal_id='$reqDealID'"),0); $myTokenID = $row['token']; ?><tr onclick="javascript:getInfo(this);" id='LoadUserApprovedCanvassItem' ><?php echo "<td style='width:5%'>".$row['id']."</td>"; echo "<td style='width:10%'>".$row['po_number']."</td>"; echo "<td style='width:8%'>".$row['date_posted']."</td>"; echo "<td style='width:10%'>".$reqCompName."</td>"; echo "<td style='width:10%'>".$reqDealName."</td>"; echo "<td style='width:20%'>".$vendorName."</td>"; echo "<td style='width:5%'>".$row['terms']." Days</td>"; echo "<td style='width:10%'>"; $poStat = mysql_result(mysql_query("SELECT `po_status` FROM `prf_po_status` WHERE `po_code`='".$row['po_status']."'"),0); echo $poStat; echo"</td>"; echo "<td style='width:15%'>".$row['remarks']."</td>"; echo "<td style='width:5%;background:transaparent;text-align:center;'> <a href='http://localhost/vts/poapr.php?id=".$row['po_number']."&uid=".$uniqueRefID."&token=".$myTokenID."' target='_Blank' styl='font-family:Yu Gothic Light;font-size:14px;font-weight:normal;color:red;'>📑</a></td>"; echo "</tr>"; } ?> </table> </div> <!--######################################## PAGINATION ############################################--> <!--######################################## PAGINATION ############################################ <div style='margin-top:50px;background:white;width:100%;padding:0px;float:left;height:70px;padding:30px'> <center> <button onclick="javascript:pageLess();" id='pageCountViewBack' class='paginationBack'>◀  Back</button> <input type='text' disabled id='pageCountView' value ="Page 1 of <?php echo $myPageCount;?>" class='paginationBox' style='width:200px;margin-left:0px'> <input type='hidden' id='pageCount' value='1' class='paginationBox'> <button onclick="javascript:pageAdd();" id='pageCountViewNext' class='paginationNext'>Next    ▶ </button> </center> </div> --> </div> <!--######################################## PAGINATION ############################################--> <!--######################################## PAGINATION ############################################--> </div> <!--########################## POPUP ACTION WINDOW FOR DELETE AND VIEW DETAILS ############################################--> <!--########################################################################################################--> <div id="showPOPostingConfirmationForm" class="PopUpActionWindow"> <div class='PopUpWindowTitle'> 🪧 CONFIRM POST ACTION <div class='PopUpWindowClose'> <b onclick="javascript:hidePOConfirmForm(this);" style='font-weight:bold'> ✕ </b> </div> </div> <table> <tr> <td style='padding:10px;padding-left:20px;width:100%;background:white;font-family:Yu Gothic; font-size:16px;color:red ;height:10px;font-weight:normal;text-align:left'> Are you sure you want to POST this Purchase Order? </td> </tr> <tr> <td colspan='1' style='padding:10px;width:250px;background:white;border-top:1px solid gray;text-align:center;padding-top:5px'> <div style='width:100%;float:right;height:50px;padding:10px;background:white'> <button onclick="javascript:showUpdatePRFForm(this);" id='viewPRFItems' class='PopUpLowerButtonR' >📑  View Details</button> <button onclick="javascript:showUpdatePRFForm(this);" id='LoadCanvassSheet' class='PopUpLowerButtonL' >🗒  Canvass Sheet</button> </div> </td> </tr> </table> </div> <!--###################################################################################################################################--> <!--###################################################################################################################################--> <div id="POActionaForm" class="purchaseOrderForm" style='background:white'> <div class='PopUpWindowTitle'> 🪧 ACTIVE P.O <div class='PopUpWindowClose'> <b onclick="javascript:hidePOActionaForm(this);" style='font-weight:bold'> ✕ </b> </div> </div> <div style='float:left;width:99%;height:60px;background:lightgray;padding:0px;margin:5px'> <div style='background:transparent;float:left;width:100%;margin:1px;text-align:center;padding:2px;border:0px solid gray;border-radius:10px'> <div style='float:left;width:20%;padding:0px;margin:0px;padding-right:10px'> <b style='float:left;color:black;padding-top:1px'>PO NUMBER</b><br> <input type='text' id='myPONumber' disabled style='width:100%;margin-left:0px;'> </div> <!--<div style='float:left;width:20%;padding:0px;margin:0px;padding-right:10px'> <b style='float:left;color:black;padding-top:1px'>PO DATE:</b><br> <input type='text' id='myPODate' disabled style='width:100%;margin-left:0px;'> </div> --> <div style='float:left;width:20%;padding:0px;margin:0px;padding-right:10px'> <b style='float:left;color:black;padding-top:1px'>DATE POSTED:</b><br> <input type='text' id='myPOPosted' disabled style='width:100%;margin-left:0px;'> </div> <div style='float:left;width:15%;padding:0px;margin:0px;padding-right:10px'> <b style='float:left;color:black;padding-top:1px'>TERMS:</b><br> <input type='text' id='myPOTerms' disabled style='width:100%;margin-left:0px;'> </div> <div style='float:left;width:20%;padding:0px;margin:0px;padding-right:10px'> <b style='float:left;color:black;padding-top:1px'>STATUS:</b><br> <input type='text' id='myPOStatus' disabled style='width:100%;margin-left:0px;'> </div> </div> </div> <input type='hidden' id='SeletedPRFItemID' class='TableBottomLabel' style='border:0px;text-align:left' disabled> <!--###################################################################################################################################--> <div id='poInformationX' style='padding:2px;width:100%;height:90px;background:w;float:left'> <div style='background:WHITE;float:left;width:100%;padding:5px;padding-top:0px;font-family:Yu Gothic Light;color:gray;font-size:14px;color:blue' id='userItemDesc'> <div id='poInformation' style='padding:0px;width:100%;height:110px;background:white'> <div style='border:0px solid lightgray;float:left;width:15%;padding:2px'> <b style='padding:1px;font-family:Yu Gothic Light;font-size:1vw'>Company Code:</b> <input type='text' disabled id='poByCompany' style='margin-bottom:5px;margin-top:0px'> <label for="notifyReq" style="font-family:Yu Gothic Light;font-size:11px;font-weight:normal;padding-top:10px"> <input type="checkbox" disabled checked id="notifyReq" name="notifyReq" value="Yes" style='font-size:10px'> Notify the requesting part </label> </div> <div style='border:0px solid lightgray;float:left;width:15%;padding:2px'> <b style='padding:1px;font-family:Yu Gothic Light;font-size:1vw'>Dealer Code:</b> <input type='text' disabled id='poByDealer' style='margin-bottom:5px;margin-top:0px'> <label for="notifyReq" style="font-family:Yu Gothic Light;font-size:11px;font-weight:normal;padding-top:10px"> </label> </div> <div style='border:0px solid lightgray;float:left;width:30%;padding:2px'> <b style='padding:3px;font-family:Yu Gothic Light;font-size:1vw'>Supplier / Vendor:</b> <input type='text' disabled id='poToVendor' style='margin-bottom:5px;margin-top:0px;'> <label for="notifyVendor" style="font-family:Yu Gothic Light;font-size:11px;font-weight:normal;padding-top:10px"> <input type="checkbox" disabled checked id="notifyVendor" name="notifyVendor" value="No" style='font-family:Yu Gothic Light;font-size:11px'> If PO is approve, notify the vendor </label> </div> <div style='border:0px solid lightgray;float:left;width:40%;padding:2px'> <b style='padding:3px;font-family:Yu Gothic Light;font-size:1vw'>Instructions:</b> <textarea rows='2' id='myInstructions' disabled style='width:100%'></textarea> </div> </div> </div> </div> <!--###################################################################################################################################--> <div id='activeItemListX' style='padding:2px;width:100%;height:190px;background:white;'> <div style='background:lightgray;float:left;width:100%;padding:3px;font-family:Yu Gothic Light;color:blue;font-size:14px;color:blue' id='userItemDesc'> <b style='font-family:Yu Gothic Light;font-size:1vw;font-weight:normal;color: #2d2d2c ;padding:1px;'> 📖 Active Items:</b> <div style='background:white;padding:2px;width:100%;height:33px;margin-bottom:0px'> <table> <thead> <th style='width:5%;padding:3px'>REC.#</th> <th style='width:10%;padding:3px'>PRF #</th> <th style='width:10%;padding:3px'>COMPANY</th> <th style='width:20%;padding:3px'>VENDOR</th> <th style='width:25%;padding:3px'>ITEM DESCRIPTION</th> <th style='width:5%;padding:3px'>UOM</th> <th style='width:10%;padding:3px'>UNIT COST</th> <th style='width:5%;padding:3px'>QTY</th> <th style='width:10%;padding:3px'>AMOUNT</th> </thead> </table> </div> <div id='activeItemList' style='background: #ffffff ;padding:2px;width:100%;height:270px;margin-top:0px;overflow:auto'> </div> </div> </div> <input type='hidden' id='itemID'> <input type='hidden' id='itemRefCode'> <!--###################################################################################################################################--> <div id='SelectedItemListX' style='padding:25px;width:100%;background:lightgray;height:90px;float:left'> <button onclick="javascript:hidePOActionaForm(this);" class='PopUpLowerButtonR' style='width:150px'>🔙   EXIT</button> <button id='cancelPO' class='PopUpLowerButtonR' style='width:180px'>❌   CANCEL P.O</button> <button id='validatePO' class='PopUpLowerButtonR' style='width:160px;display:none'>📌   VALIDATE</button> <button id='PostNewPO' class='PopUpLowerButtonR' style='width:160px;display:none'>📌   POST PO</button> </div> <!--###################################################################################################################################--> </div> <!--###################################################################################################################################--> <!--###################################################################################################################################--> </body> </html> <!--- LOCALIZED COPY OF JAVASCRIPT --> <script type="text/javascript" src="http://code.jquery.com/jquery-1.9.1.js"></script> <script type="text/javascript"> $(document).ready(function(){ $("#cancelPO").click(function(){ var myPOStatus = $("#myPOStatus").val(); var myPONumber = $("#myPONumber").val(); //alert(myPOStatus); //exit; if(myPOStatus === 'Unposted'){ alert('ERROR: This PO hasn\'t been posted yet.'); exit; }else{ if(confirm("CONFIRM DELETE ACTION: \n\nAre you sure you want to CANCEL this P.O? \n\n Press 'OK' button to proceed...")){ ShowUploadBar(); $.ajax({ url: "PRF_CANCEL_PO.php", type: "POST", async: false, data: { "myPONumber": myPONumber, "done": 1 }, success: function(d){ hidePOActionaForm(); ShowUploadBar(); $("#mainTableSub").html(d); } }) } } }); <!--###################################################################################################################################--> <!--###################################################################################################################################--> $("#validatePO").click(function(){ var myPONumber = $("#myPONumber").val(); var myPOStatus = $("#myPOStatus").val(); // alert(myPONumber); //exit; //if(confirm("CONFIRM DELETE ACTION: \n\nAre you sure you want to DELETE this record? \n\n Press 'OK' button to proceed...")){ ShowUploadBar(); $.ajax({ //url: "PRF_validatePO.php", url: "PRF_PO_REVALIDATE.PHP", type: "POST", async: false, data: { "myPONumber": myPONumber, "done": 1 }, success: function(d){ hidePOActionaForm(); ShowUploadBar(); showtopMessage(); $("#topMessage").html(d); } }) }); <!--###################################################################################################################################--> <!--###################################################################################################################################--> $("#getPONumber").click(function(){ ShowUploadBar(); $.ajax({ url: "prf_getPONumber.php", type: "POST", async: false, data: { "done": 1 }, success: function(d){ $("#myPONumber").val(d); document.getElementById("getPONumber").disabled = true; ShowUploadBar(); } }) }); <!--###################################################################################################################################--> <!--###################################################################################################################################--> $("#PostNewPO").click(function(){ var itemRefCode = $("#itemRefCode").val(); var myPONumber = $("#myPONumber").val(); //alert(itemRefCode); //exit; ShowUploadBar(); $.ajax({ url: "PRF_POST_PO.php", type: "POST", async: false, data: { "itemRefCode": itemRefCode, "myPONumber": myPONumber, "done": 1 }, success: function(d){ showtopMessage(); updateForPOCreation(); ShowUploadBar(); hidePOActionaForm(); } }) }); <!--###################################################################################################################################--> <!--######################################################################PRF_POST_PO.php#############################################################--> $("#LoadUserApprovedCanvassItem").click(function(){ var myPONumber = $("#myPONumber").val(); //alert(myPONumber); //exit; if(myPONumber==''){ alert('ERROR: PO Number is missing.'); exit; } ShowUploadBar(); $.ajax({ url: "PRF_POViewingOfItemsOnly.php", type: "POST", async: false, data: { "myPONumber": myPONumber, "done": 1 }, success: function(d){ $("#activeItemList").html(d); ShowUploadBar(); } }) }); //============================================================================================================================= //============================================================================================================================= $("#addToPORequestDelete").click(function(){ var itemID = $("#itemID").val(); var itemRefCode = $("#itemRefCode").val(); var myPONumber = $("#myPONumber").val(); //alert(itemID); //exit; if(myPONumber==''){ alert('ERROR: PO Number is missing.'); exit; } ShowUploadBar(); $.ajax({ url: "PRF_PODeleteToOpenPO.php", type: "POST", async: false, data: { "itemID": itemID, "myPONumber": myPONumber, "itemRefCode": itemRefCode, "done": 1 }, success: function(d){ $("#activeItemList").html(d); ShowUploadBar(); hideDelPOedItem(); reloadItemForPO(); showActiveProposal(); showPOedItemPerSelectedVendorAndCompany(); } }) }); //============================================================================================================================= //============================================================================================================================= $("#createPurchaseOrderForApproval").click(function(){ var notifyReq = $("#notifyReq").val(); var notifyVendor = $("#notifyVendor").val(); var poToVendor = $("#poToVendor").val(); var poByCompany = $("#poByCompany").val(); var myPONumber = $("#myPONumber").val(); //alert(canvassID); //exit; if(AwardItemID==''){ alert('ERROR: No item was selected'); exit; } if(canvassID==''){ alert('ERROR: Please select proposal to continue...'); exit; } if(AwardItemQty==''){ alert('ERROR: Invalid Quantity'); exit; } if(AwardItemAmount==''){ alert('ERROR: Invalid Amount'); exit; } ShowUploadBar(); $.ajax({ url: "PRF_EXECOM_AwardToVendor.php", type: "POST", async: false, data: { "AwardItemID": AwardItemID, "canvassID": canvassID, "AwardItemAmount": AwardItemAmount, "AwardItemQty": AwardItemQty, "done": 1 }, success: function(d){ $("#mainTableSub").html(d); hideConfirmedItem(); ShowUploadBar(); UpdateExecomForApprovalCount(); } }) }); //============================================================================================================================= //============================================================================================================================= }); </script> <!--- LOCALIZED COPY OF JAVASCRIPT --> <script type="text/javascript"> //============================================================================================================================= //============================================================================================================================= function showActiveVendors(){ var poByCompany = $("#poByCompany").val(); //alert(poByCompany); //exit; ShowUploadBar(); $.ajax({ url: "PRF_LoadActiveVendorslBasedOnSelectedCompany.php", type: "POST", async: false, data: { "poByCompany": poByCompany, "done": 1 }, success: function(d){ $("#poToVendor").html(d); ShowUploadBar(); } }) } //============================================================================================================================= //==================================.php=========================================================================================== function reloadItemForPO(){ ShowUploadBar(); $.ajax({ url: "PRF_ReLoadForPOItems.php", type: "POST", async: false, data: { "done": 1 }, success: function(d){ $("#mainTableSub").html(d); ShowUploadBar(); } }) } //============================================================================================================================= //==================================.php=========================================================================================== function showActiveProposal(){ var poByCompany = $("#poByCompany").val(); var loadActiveProposal = $("#poToVendor").val(); //alert(loadActiveProposal); //exit; ShowUploadBar(); $.ajax({ url: "PRF_LoadProposalBasedOnSelectedCompany.php", type: "POST", async: false, data: { "poByCompany": poByCompany, "loadActiveProposal": loadActiveProposal, "done": 1 }, success: function(d){ $("#activeItemList").html(d); showPOedItemPerSelectedVendorAndCompany(); ShowUploadBar(); reloadItemForPO(); } }) } //============================================================================================================================= //============================================================================================================================= function showPOedItemPerSelectedVendorAndCompany(){ var poByCompany = $("#poByCompany").val(); var poToVendorID = $("#poToVendor").val(); var myPONumber = $("#myPONumber").val(); //alert(poCode); //exit; ShowUploadBar(); $.ajax({ url: "PRF_LoadPOedItemByVendor.php", type: "POST", async: false, data: { "poByCompany": poByCompany, "myPONumber": myPONumber, "poToVendorID": poToVendorID, "done": 1 }, success: function(d){ $("#SelectedItemList").html(d); ShowUploadBar(); } }) } function hidetopMessage(){ $("#topMessage").fadeOut(20800); } function showtopMessage(){ $("#topMessage").fadeIn(100); hidetopMessage(); } function hidePOConfirmForm(){ $("#showPOPostingConfirmationForm").fadeOut(500); } function showPOConfirmForm(){ $("#showPOPostingConfirmationForm").fadeIn(500); } function hidePOActionaForm(){ $("#POActionaForm").fadeOut(500); } function showPOActionaForm(){ $("#POActionaForm").fadeIn(500); //validatePO postPO var myPOStatus = $("#myPOStatus").val(); //alert(myPOStatus); if(myPOStatus == "For Validation"){ $('#validatePO').css("display","block"); $('#postPO').css("display","None"); //$("#validatePO").fadeIn(100); //$("#postPO").fadeOut(100); } if(myPOStatus == "Unposted"){ $('#validatePO').css("display","none"); $('#postPO').css("display","block"); //$("#validatePO").fadeOut(100); //$("#postPO").fadeIn(100); } } function hidePOForm(){ $("#showGenCanvassForm").fadeOut(500); document.getElementById("poByCompany").disabled = false; document.getElementById("poToVendor").disabled = false; document.getElementById("myInstructions").disabled = false; document.getElementById("myInstructions").value = ''; document.getElementById("myPONumber").value = ''; document.getElementById("disabled").disabled = false; hideActionForm(); }; function showPOForm(){ document.getElementById("poByCompany").disabled = false; document.getElementById("poToVendor").disabled = false; document.getElementById("myInstructions").disabled = false; document.getElementById("myInstructions").value = ''; document.getElementById("poByCompany").value = ''; document.getElementById("poToVendor").value = ''; document.getElementById("myInstructions").value = ''; //document.getElementById("myPONumber").value = ''; $("#showGenCanvassForm").fadeIn(500); } function getInfo(row) { //var postPOc = $("#postPO").val(); showPOActionaForm(); var x=row.cells; document.getElementById("myPONumber").value = x[1].innerHTML; document.getElementById("myPOPosted").value = x[2].innerHTML; document.getElementById("poByCompany").value = x[3].innerHTML; document.getElementById("poByDealer").value = x[4].innerHTML; document.getElementById("poToVendor").value = x[5].innerHTML; document.getElementById("myPOTerms").value = x[6].innerHTML; document.getElementById("myInstructions").value = x[8].innerHTML; document.getElementById("myPOStatus").value = x[7].innerHTML; } //================================================================================= //================================================================================= $("#pageCountViewNext").click(function(){ var MyPageCount = $("#MyPageCount").val(); var MyRowCount = $("#MyRowCount").val(); var myOffSet = $("#myOffSet").val(); var CurrentpageCount = $("#pageCount").val(); var recordPerPage = $("#recordPerPage").val(); //alert(CurrentpageCount); //exit; ShowUploadBar(); $.ajax({ url: "prf_loadActivePO.php", type: "POST", async: false, data: { "MyPageCount": MyPageCount, "myOffSet": myOffSet, "MyRowCount": MyRowCount, "CurrentpageCount": CurrentpageCount, "recordPerPage": recordPerPage, "done": 1 }, success: function(d){ ShowUploadBar(); $("#mainTableSub").html(d); } }) }); //================================================================================= //================================================================================= $("#pageCountViewBack").click(function(){ var MyPageCount = $("#MyPageCount").val(); var MyRowCount = $("#MyRowCount").val(); var myOffSet = $("#myOffSet").val(); var CurrentpageCount = $("#pageCount").val(); var recordPerPage = $("#recordPerPage").val(); //alert(CurrentpageCount); //exit; ShowUploadBar(); $.ajax({ url: "prf_loadActivePO.php", type: "POST", async: false, data: { "MyPageCount": MyPageCount, "myOffSet": myOffSet, "MyRowCount": MyRowCount, "CurrentpageCount": CurrentpageCount, "recordPerPage": recordPerPage, "done": 1 }, success: function(d){ ShowUploadBar(); $("#mainTableSub").html(d); } }) //================================================================================= //================================================================================= }); //====================================================================================================== function updateForPOCreation(){ $.ajax({ url: "PRF_UpdateForPOCreation.php", type: "POST", async: false, data: { "trans":2 }, success: function(d){ $("#forPOCreation").html(d); } }) } </script> PK��Z�q/i��/i��connect.phpnu��[��<?php ob_start(); include 'core/init.php'; protected_page(); $ASAADM = $user_data['ASA_ADM']; $ITADMIN = $user_data['IT_ADM']; $CHCOMP = $user_data['CH_COMP']; $myCompany = $user_data['company']; $chkDeptID = $user_data['dept_id']; $chkDeptHeadID = $user_data['dept_head_id']; $myCurrentDept = mysql_result(mysql_query("SELECT `dept_name` FROM `vts_departments` WHERE `id`='$chkDeptID'"),0); if($myCurrentDept==0){ $deptName = "--Select Department--"; }else{ $deptName = $myCurrentDept; } if($chkDeptID == 0 \|\| $chkDeptHeadID == 0){ echo "<div id='showProfile' style='position:fixed;top:10px;left:10px;width:450px;border:1px solid gray; background:#ffffff;display:block;height:370px;z-index:9999999999'>"; ?> <div style='vertical-align:top;height:35px;margin:0px;width:100%;border-bottom:1px solid gray;padding:5px;font-family:Yu Gothic;font-size:16px;font-weight:normal;color: #f7f8f9 ;text-align:left;background:#191919;'> 🗒 UPDATE YOUR PROFILE <div style='display:none;float:right;font-family:Calibri;font-size:18px;margin-right:5px;color: #f7f8f9;cursor:pointer;'> <b id='closCategory' onclick="javascript:hideItemCategoryForm(this);" style='font-weight:bold'> ✕ </b> </div> </div> <!--BODY--> <div style='width:100%;height:80%;padding:30px;border:0px solid red;background:white;color:red;padding-bottom:10px;font-family:Yu Gothic Light;font-size:16px;font-weight:normal' id='ClassList'> <b>WARNING! Additional information is required.</b><br><br>Please select your department. <select id ='myDepartment' style='width:100%;padding:1px;font-family:Yu Gothic Light;font-size:14px; color black;margin:0px'> <option value=''>--Select Department--</option> <?php $getDept = mysql_query("SELECT * FROM `vts_departments` WHERE `deleted`=0 ORDER BY `dept_name` ASC"); while($row = mysql_fetch_array($getDept)){ echo "<option value='".$row['id']."'>".strtoupper($row['dept_name'])."</option>"; } ?> </select> <br> <!-- YOU CAN ONLY VIEW LIST OF EMPLOYEES WITHIN THE SAME COMPANY--> <br>Department Manager/Head? <select id ='myDepartmentHead' style='width:100%;padding:1px;font-family:Yu Gothic Light;font-size:14px; color black;margin:0px'> <option value=''>--Department Head--</option> <?php $getDeptHead = mysql_query("SELECT * FROM `vts_users` WHERE `u_status`=1 ORDER BY `u_lname` ASC"); while($row = mysql_fetch_array($getDeptHead)){ echo "<option value='".$row['u_id']."'>".strtoupper($row['u_lname']).", ".strtoupper($row['u_fname'])."</option>"; } ?> </select> <button id='updateDept' style='width:150px;float:right;margin:20px;margin-right:0px;margin-top:50px;padding:3px;cursor:pointer;font-family:Yu Gothic Light;color:white;font-weight:bold;background:black'>Update</button> </div> <?php echo "</div>"; } //echo $user_data['u_id']; //break; //https://www.allphptricks.com/demo/ //https://html-css-js.com/html/character-codes/icons/ //https://philippinescities.com/region-13-caraga-region/ RIGION AND CITIES WEBSITE REFERENCE $userID=$user_data['u_id']; $userFName=$user_data['u_fname']; $myCurTime=$currentTime; $dealID= $user_data['dealer']; $compID= $user_data['company']; $accType =$user_data['account_type']; $getBookingCount = 0;//mysql_result(mysql_query("SELECT COUNT('s_id') FROM `vts_service_transaction` WHERE `booking_confirmed`='no'"),0); $comID=$user_data['company']; if(isset($_GET['company'])){ $comName=$_GET['company'];//mysql_result(mysql_query("SELECT `comp_code` FROM `vts_company` WHERE `comp_id`='$comID'"),0); }else{ $comName = mysql_result(mysql_query("SELECT `comp_code` FROM `vts_company` WHERE `comp_id`='$comID'"),0); } echo "<input type='hidden' id='activeBrand'>"; echo "<input type='hidden' id='MyCompName'>"; echo " <input type='hidden' id='UserCompanyName' value='".$comName."'>"; echo "<input type='hidden' id='MyUserID' value='".$userID."'>"; echo "<input type='hidden' id='MyUserFName' value='".$userFName."'>"; //$comName=mysql_result(mysql_query("SELECT `comp_code` FROM `vts_company` WHERE `comp_id`='$comID'"),0); $userBrand=mysql_result(mysql_query("SELECT `brand` FROM `vts_company` WHERE `comp_code`='$comName'"),0); $BrandID=mysql_result(mysql_query("SELECT `b_id` FROM `vts_brands` WHERE `b_name`='$userBrand'"),0); $_SESSION["ActiveID"]=$userID; //echo ($_SESSION[ActiveID]); //if($accType !='Admin' \|\| $accType !='Super Admin'){ // Header("Location:user_Portal.php?id=$userID"); //} //echo "Arnel ".$myCurTime; //count all new bookings $getBookingCount = 0;//mysql_result(mysql_query("SELECT COUNT('s_id') FROM `vts_service_transaction` WHERE `booking_confirmed`='no'"),0); $imgF = RAND(1,24); ?> <!DOCTYPE html> <html> <head> <title>AUTOHUB CONNECT</title> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <link rel="stylesheet" href="css/style_menu.css"> <link rel="stylesheet" href="css/style.css"> <link rel="icon" href="images/ahg_logo.png"> <script src="sweetalert2.min.js"></script> <link rel="stylesheet" href="sweetalert2.min.css"> <!--- LOCALIZED COPY OF JAVASCRIPT --> <!--- LOCALIZED COPY OF JAVASCRIPT --> <!--- MENU BAR CLICK HIDE/SHOW SLIDE EFFECT --> <script src="//cdn.jsdelivr.net/npm/sweetalert2@11"></script> <script src="script/sweetalert2.all.min.js"></script> <!--<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>--> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script> <!--<script src="https://code.jquery.com/jquery-3.2.1.min.js"></script> --> <!--- LOCALIZED COPY OF JAVASCRIPT --> <!--<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>--> <!--<script type="text/javascript" src="https://code.jquery.com/jquery-1.9.1.js"></script> --> <!-- add jquery https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js --> <script type="text/javascript" src="https://code.jquery.com/jquery-3.6.0.js"></script> <script> $(document).ready(function(){ $("#barMenu").click(function(){ $("#panel").slideDown("slow"); }); }); $(document).ready(function(){ $("#panel").click(function(){ $("#panel").slideUp("slow"); }); }); function ShowUploadBar() { var div = document.getElementById("loadBaraData"); if (div.style.display == 'none') { div.style.display = ''; } else { div.style.display = 'none' } } </script> <!--- MENU BAR CLICK HIDE/SHOW SLIDE EFFECT --> <!--<script src="https://code.jquery.com/jquery-3.2.1.min.js"></script> --> <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script> <!--<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>--> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script> <!--<div id="wait" style="display:none;width:400px;height:100px;border:0px solid red;position:absolute;top:50%;left:45%;padding:2px;z-index:999999999999999999"> <img src='images/demo_wait.gif' width="64" height="64" /><br>Processing...</div> --> <!-- add jquery --> <!--<script type="text/javascript" src="https://code.jquery.com/jquery-1.9.1.js"></script> --> <script type="text/javascript"> window.onload = function () { ShowUploadBar(); $.ajax({ url: "main_app_new.php", type: "get", dataType: "text", success: function(data){ ShowUploadBar(); $('#displayBox').html(data); } }); } $(document).ready(function(){ $(document).ajaxStart(function(){ $("#wait").css("display", "block"); }); $(document).ajaxComplete(function(){ $("#wait").css("display", "none"); }); //========================================================================================= //ALL FUNCTIONS STARTS HERE //========================================================================================= //==================================== $("#updateDept").click(function(){ var myDepartment =$("#myDepartment").val(); var MyUserID =$("#MyUserID").val(); var myDepartmentHead =$("#myDepartmentHead").val(); if(myDepartment==''){ alert('Please select your department to continue...'); exit(); } if(myDepartmentHead==''){ alert('Please select your department head to continue...'); exit(); } //alert(myDepartment); //exit ShowUploadBar(); $.ajax({ url: "vts_updateDepartment.php", type: "POST", async: false, data: { "myDepartmentHead":myDepartmentHead, "myDepartment":myDepartment, "MyUserID":MyUserID, "done":1 }, success: function(d){ ShowUploadBar(); $("#showProfile").fadeOut(500); } }) }); //==================================== $("#loadSalesModule").click(function(){ ShowUploadBar(); $.ajax({ url: "sales_module.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); $("#displayBox").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //====================================xxxxx //==================================== $("#loadHelpdeskPage").click(function(){ ShowUploadBar(); $.ajax({ url: "support_helpdesk_module.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); $("#displayBox").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //==================================== //==================================== $("#myDashboard").click(function(){ ShowUploadBar(); $.ajax({ url: "main_app.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); $("#displayBox").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //==================================== //==================================== //==================================== $("#backHome").click(function(){ ShowUploadBar(); $.ajax({ url: "dashboard_main.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); $("#displayBox").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //==================================== //==================================== $("#UpdateMyCompany").click(function(){ var MyCompany = $("#MyCompany").val(); if(MyCompany==''){ alert(MyCompany); return false; } ShowUploadBar(); $.ajax({ url: "CL_UPDATE_COMPANY_ACCESS.php", type: "POST", async: false, data: { "MyCompany":MyCompany, "done":1 }, success: function(d){ ShowUploadBar(); hideChangeCompany(); //$("#displayBox").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //==================================== //========================================================================================= //ALL FUNCTIONS ENDS HERE //========================================================================================= }); function hideChangeCompany(){ $("#changeMyCompany").fadeOut(500); }; function showChangeCompany(){ $("#changeMyCompany").fadeIn(500); }; </script> <style> <!--START of bar hide/show effect--> .SavePostCloseButton{ float:right;font-family:Yu Gothic;color:black;font-size:16px;margin:5px;width:180px;height:40px;border-radius:3px;font-weight:normal; } .SavePostCloseButton:hover{ float:right;font-family:Yu Gothic;font-weight:bold;color:red;font-size:16px;margin:5px;width:180px;height:40px;border-radius:3px;cursor:pointer; } .orangeBG{ background: -webkit-linear-gradient(left top,#F34410 ,#f9b709); /* For Safari 5.1 to 6.0 / background: -o-linear-gradient(bottom right, #F34410,#f9b709); / For Opera 11.1 to 12.0 / background: -moz-linear-gradient(bottom top, #F34410,#f9b709); / For Firefox 3.6 to 15 / background: linear-gradient(to bottom right, #F34410,#f9b709); / Standard syntax / } .greenBG{ background: -webkit-linear-gradient(left top,#3cd408,#b0fe95); / For Safari 5.1 to 6.0 / background: -o-linear-gradient(bottom right, #3cd408,#b0fe95); / For Opera 11.1 to 12.0 / background: -moz-linear-gradient(bottom top, #3cd408,#b0fe95); / For Firefox 3.6 to 15 / background: linear-gradient(to bottom right, #3cd408, #b0fe95); / Standard syntax / } .grayBG{ background: -webkit-linear-gradient(left top,#83827d, #cdccaa, #fff); / For Safari 5.1 to 6.0 / background: -o-linear-gradient(bottom right, #83827d, #cdccaa, #fff); / For Opera 11.1 to 12.0 / background: -moz-linear-gradient(bottom top, #83827d, #cdccaa, #fff); / For Firefox 3.6 to 15 / background: linear-gradient(to bottom right, #83827d, #cdccaa, #fff); / Standard syntax / } #panel, #flip { padding: 5px; text-align: center; background-color: #e5eecc; border: solid 1px #c3c3c3; } #panel { padding: 50px; display: none; } <!--end of bar hide/show effect--> .topBG{ background: -webkit-linear-gradient(left top, #f96409, #f99e09 , #fad497); / For Safari 5.1 to 6.0 / background: -o-linear-gradient(bottom right, #f96409,#f99e09, #fad497 ); / For Opera 11.1 to 12.0 / background: -moz-linear-gradient(bottom top, #f96409,#f99e09, #fad497 ); / For Firefox 3.6 to 15 / background: linear-gradient(to bottom right, #f96409,#f99e09, #fad497 ); / Standard syntax / font-weight:bold; color:black; } .bgColor{ background: -webkit-linear-gradient(left top,#ff8430, #f9cc5f,#fff ); / For Safari 5.1 to 6.0 / background: -o-linear-gradient(bottom right, #ff8430, #f9cc5f,#fff); / For Opera 11.1 to 12.0 / background: -moz-linear-gradient(bottom top, #ff8430, #f9cc5f,#fff); / For Firefox 3.6 to 15 / background: linear-gradient(to bottom right, #ff8430, #f9cc5f,#fff ); / Standard syntax / } .addBrandLink{ display:block; padding:10px; padding-left:15px; padding-right:15px; margin:10px; border:1px solid #0ca7f4; margin-left:0px; margin-right:0px; background:#1cd9fe; font-family:Arial; font-size:14px; font-weight:normal; } .addBrandLink:hover{ display:block; padding:10px; padding-left:15px; padding-right:15px; margin:10px; border:1px solid #fa824f ; margin-left:0px; margin-right:0px; background:#f7e581; font-family:Arial; font-size:14px; font-weight:bold; } .bodyMenu{ float:left; width:55%; border:0px solid red; } .bodyTitle{ float:left; width:40%; border:0px solid red; padding:10px; display:block; } .myDashBoard{ display:block; float:left; width:20%; height:auto; border:0px solid gray; background:white; border-right:1px solid gray; } .myBody{ display:block; float:left; width:80%; height:900px; min-width:400px; border:0px solid gray; background:white; padding:10px; } .fHeaderA{ float:left; width:30%; min-width:200px; border:0px solid red; } .fHeaderB{ float:left; width:70%; min-width:200px; border:0px solid red; } .GradientOrange{ background: -webkit-linear-gradient(left top, #fb8b1b, #fea64f , #fbc337 ); / For Safari 5.1 to 6.0 / background: -o-linear-gradient(bottom right, #fb8b1b,#fea64f, #fbc337 ); / For Opera 11.1 to 12.0 / background: -moz-linear-gradient(bottom top, #fb8b1b,#fea64f, #fbc337 ); / For Firefox 3.6 to 15 / background: linear-gradient(to bottom right, #fb8b1b,#fea64f, #fbc337 ); / Standard syntax / } .mainMenu{ width:auto; float:left; background-color:black; display:block; } .barMenu{ width:auto; float:right; font-size:100px; display:none; border:1px solid #252323; } .barMenuShow{ display:none; } <!--END OF DROP DOWN VERTICAL MEN----> .vertical-menu { width: 250px; background-color: #e0f5fa ; } .vertical-menu a { background-color: #e0f5fa ; color: black; display: block; padding: 12px; text-decoration: none; } a{ text-decoration:none; } .vertical-menu a:hover { background-color: yellow ; } .vertical-menu a.active { background: -webkit-linear-gradient(left top, #e5f7fc, #95e5fa, #e5f7fc ); / For Safari 5.1 to 6.0 / background: -o-linear-gradient(bottom right, #e5f7fc,#95e5fa,#e5f7fc); / For Opera 11.1 to 12.0 / background: -moz-linear-gradient(bottom top, #e5f7fc,#95e5fa,#e5f7fc); / For Firefox 3.6 to 15 / background: linear-gradient(to bottom right, #e5f7fc,#95e5fa,#e5f7fc); / Standard syntax / color: red; } { box-sizing: border-box; } .newsFeed{ width:25%; background:white; border:0px solid white; border-right:1px solid #f4f6f6 ; padding-top:20px; } .menu { float:left; width:20%; min-width:200px; text-align:left; border:0px solid red; top-margin:2px; } .menu a { background-color:#e0f5fa ; padding:1px; margin-top:1px; display:block; width:100%; color:black; } .main { float:left; width:80%; padding:0 20px; min-width:400px; } .addCustForm{ width:70%; } .right { background-color:#e5e5e5; float:left; width:20%; padding:1px; margin-top:1px; text-align:center; } .DIVBox{ font-family:Arial; background: -webkit-linear-gradient(left top, #d2fbf3,#f0f0dd, #f0f0dd ); /* For Safari 5.1 to 6.0 / background: -o-linear-gradient(bottom right, #d2fbf3,#f0f0dd ,#f0f0dd); / For Opera 11.1 to 12.0 / background: -moz-linear-gradient(bottom top, #d2fbf3,#f0f0dd,#f0f0dd); / For Firefox 3.6 to 15 / background: linear-gradient(to bottom right, #d2fbf3,#f0f0dd,#f0f0dd); / Standard syntax / font-size:12px; color:black; border:0px solid orange; width:22%; height:10%; min-width:250px; min-height:150px; float:left; margin:1%; } .DIVBox:hover{ font-family:Arial; background: -webkit-linear-gradient(left top, #fdfdac ,#f0f0dd,#f0f0dd ); background: -o-linear-gradient(bottom right, #fdfdac,#fdfdac,#f0f0dd); background: -moz-linear-gradient(bottom top, #fdfdac,#fdfdac,#f0f0dd); background: linear-gradient(to bottom right, #fdfdac,#fdfdac,#f0f0dd); font-size:12px; color:black; border:1px solid red; width:22%; height:10%; min-width:250px; min-height:150px; float:left; margin:1%; } .pageMenuA{ width:40%; float:left; margin:5px; border:0px solid blue; } .pageMenuB{ width:50%; float:right; margin:5px; border:0px solid blue; } @media only screen and (max-width:900px) { / For mobile phones: / .menu, .main, .right { width:100%; } .mainMenu{ width:100%; float:left; background-color:black; display:none; } .barMenuText{ background-color:black #565554 ; font-family:Calibri; color:white; font-size:16px; font-weight:bold; } .mainMenuShow{ width:100%; background-color:black; display:block; float:left; width:100%; border-bottom:1px solid #3f3e3d; padding:10px; margin:0px; font-size:20px; color:white; } .barMenu{ width:auto; float:right; display:block; border:1px solid #3f3e3d; } .bDashboard{ width:100% !important; } .addCustForm{ width:100% !important; } .newsFeed{ width:100% !important; } .menu{ display:none !important; } .subBody{ width:100% !important; } .vertical-menuA a.active { color: red; } .DIVBox{ width:94%; margin:2%; } .DIVBox:hover{ width:94%; margin:2%; } .vertical-menuB a.active { background: -webkit-linear-gradient(left top, #dbe0dc ,#ccd3cd, #f7f5f7); / For Safari 5.1 to 6.0 / background: -o-linear-gradient(bottom right, #dbe0dc,#ccd3cd,#f7f5f7); / For Opera 11.1 to 12.0 / background: -moz-linear-gradient(bottom top, #dbe0dc,#ccd3cd,#f7f5f7); / For Firefox 3.6 to 15 / color: red; } .fHeaderA{ float:left; width:100%; min-width:200px; border:0px solid red; } .fHeaderB{ display:none; float:left; width:100%; min-width:200px; border:0px solid red; } .myDashBoard{ display:none; float:left; width:100%; min-width:200px; border:1px solid red; } .myBody{ display:block; float:left; width:100%; min-width:200px; border:0px solid red; } .bodyTitle{ float:left; width:40%; border:0px solid red; padding:10px; display:none; } .bodyMenu{ float:left; width:100%; border:0px solid red; } .pageMenuA{ width:100%; float:left; margin:5px; border:0px solid blue; } .pageMenuB{ width:100%; float:right; margin:5px; border:0px solid blue; } } .headerDiv{ background-image: url(./images/log_bg.jpg); background-size: cover; background-repeat: no-repeat; background-position: center center; position: fixed; top: 0; left: 0; padding:5px; z-index: 999; height: 80px; width: 100%; } #displayMenu{ background: #E3E0DE; width: 20%; height: auto% } .orangeBG{ background: -webkit-linear-gradient(left top,#F34410 ,#f9b709); / For Safari 5.1 to 6.0 / background: -o-linear-gradient(bottom right, #F34410,#f9b709); / For Opera 11.1 to 12.0 / background: -moz-linear-gradient(bottom top, #F34410,#f9b709); / For Firefox 3.6 to 15 / background: linear-gradient(to bottom right, #F34410,#f9b709); / Standard syntax / } .appMenu{ min-width:250px;width:100%;float:left;height:100px;border:0px;border-bottom:1px solid lightgray;padding:20px;background:#eff1f1;cursor:pointer; } .appMenu:hover{ min-width:250px;width:100%;float:left;height:100px;border:0px;border-bottom:1px solid lightgray;padding:20px;background: #f7d768;cursor:pointer; } <!-- NEW SET OF VERTICAL MENU CSS --> </style> </head> <body style="font-family:Verdana;color:#aaaaaa;background:white"> <!--#########################################################################--> <div id="loadBaraData" style="display:none;position:fixed;top:40%;left:45%;width:50px;padding:5px;padding-left:2px;padding-right:2px;height:50px;background:transparent;z-index:9999;border:0px solid gray;z-index:999999999999999999"> <div id="uploadBar" style="padding-bottom:5px;font-family:Yu Gothic Light;font-size:14px;color: #d109b0;font-weight:normal ;text-align:center;margin-top:0px;background:#ffffff ;display:block;width:100px;height:95px;border-radius:10px;position:relative;left:5px;padding:8px;z-index:999999999999999999;border:1px solid gray "> <img src='images/ajaxLoader2.gif' width="auto" height="auto" style='margin:10px;margin-bottom:5px'/><center>Please wait<center></div> </div> <div class='topMenu' style="margin:0px;padding:0px; text-align:left;"> <div class="headerDiv"> <div class="fHeaderA"> <br> <a href="#" id="HideShowMenu" style="padding:0px;padding-top:30px;font-family:Calibri;font-size:30px;font-weight:bold;color: #ffffff ">☰</a> </div> <div class="fHeaderB"> <?php echo "<p style='padding:10px;font-family:Arial;font-size:14px;color:black;float:right;background: #fff ;border-radius:20px;opacity:.9'><a href='connect.php'>◀   HOME</a>    \| 🔐: ".strtoupper($accType)."      \|     👩 User: ".strtoupper($user_data['u_name'])."      \|      <a href='#' id='changeCompany' onclick='showChangeCompany()' style='cursor:pointer'>▼</a> Company: ".$comName."     \|     <a href='logout.php'>&#10060 Logout</a></p>";?></div> </div><br> <div id='changeMyCompany' style='display:none;position:absolute;z-index:88888888888888888888;width:500px;height:250px;top:100px;left:100px;border:1px solid gray;background:white'> <div class='bgColor' style='vertical-align:top;height:30px;margin:0px;width:100%;border-bottom:1px solid gray;padding:5px;font-family:Verdana;font-size:16px;font-weight:normal;color:#043062;text-align:left;'> ☶ CHANGE COMPANY ASSIGNMENT: <div style='float:right;font-family:Calibri;font-size:18px;'> <a href='#' onclick='hideChangeCompany()' style='font-weight:bold'> ✕ </a> </div> </div> <?php $getCompanyList = mysql_query("SELECT FROM `cl_access` WHERE `status` = 1 AND `user_id`='$userID' ORDER BY `id` ASC"); if($CHCOMP == 0){ echo "<p style='text-align:center;padding:10px;margin:10%;margin-top:5%;margin-bottom:5%;font-family:Arial;font-size:14px;color:red'>Sorry, You are not allowed to change your company assignment. Please contact your system administrator for assistance. <br><br>Thank you!</p>"; echo "<input type='submit' value='CLOSE' onclick='hideChangeCompany()' style='width:80%;padding:10px;margin-left:10%;margin-top:0px;font-family:Calibri;font-size:16px;'>"; }else{ echo "<br><br><b style='font-family:Calibri;font-size:14px;color:black;margin-left:10%;'>CHANGE COMPANY ACCESS:</b>"; echo "<select id='MyCompany' style='border:1px solid gray;padding:5px;width:80%;margin-left:10%;margin-top:20px'>"; echo "<option value=''>-- Select Company --</option>"; while($row = mysql_fetch_array($getCompanyList)){ $CLCompAccessID = $row['comp_id']; $companyName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$CLCompAccessID'"),0); echo "<option value='".$CLCompAccessID."'>".$companyName."</option>"; } echo "</select>"; echo "<input type='submit' id='UpdateMyCompany' value='UPDATE ACCESS' style='width:80%;padding:10px;margin-left:10%;margin-top:30px;font-family:Calibri;font-size:16px;height:40px'>"; } ?> </div> <div style='height:65px;width;30%;padding:5px;'> </div> <div id="anchor" style='border:2px solid black;padding:0px;text-align:right;padding-right:0px;background:black'> <!-- START OF MENU CODE --> </div> <script> function myFunction() { var x = document.getElementById("myTopnav"); if (x.className === "topnav") { x.className += " responsive"; } else { x.className = "topnav"; } } </script> <!-- END OF MENU CODE --> </div> <div id="displayBox" style="width:100%;height:auto;margin:0px;border:0px solid red;padding:0px;height:750px;min-width:1366px"> </div> </body> </html> PK��Z�w<7��PRF_procurement_page.phpnu��[��<?php ob_start(); include 'core/init.php'; protected_page(); $ADMAccess = $user_data['CL_ADM']; $PAYADM = $user_data['PAY_ADM']; $HRDADM = $user_data['HRD_ADM']; $CHKADM = $user_data['CHK_ADM']; $TREADM = $user_data['TRE_ADM']; $LEGADM = $user_data['LEG_ADM']; $RESADM = $user_data['RES_ADM']; $CHKCRE = $user_data['CHK_CRE']; $OBLADM = $user_data['OBL_ADM']; $PRFPRO = $user_data['PRFPRO']; $PRFPUR = $user_data['PRFPUR']; $PRFSET = $user_data['PRFSET']; $MATRIX = $user_data['MATRIX']; $ITMASTER= $user_data['ITMASTER']; $MyDeptID=$user_data['dept_id']; $userID=$user_data['u_id']; $chkIfMemberofExecom = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_execommembers` WHERE `execom_id`='$userID' AND `deleted`=0 AND `authority`=3"),0); echo "<input type='hidden' id='isEXECOM' value='".$chkIfMemberofExecom."'>"; $comID=$user_data['company']; echo "<input type='hidden' id='passCompID' value='".$comID."'>"; ?> <!DOCTYPE html> <html> <head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <link rel="stylesheet" href="css/styleP.css"> <!--- LOCALIZED COPY OF JAVASCRIPT --> <script src="js/jquery-1.11.0.min.js" type="text/javascript"></script> <script type="text/javascript"> $(document).ready(function () { yourFunction(); }); function yourFunction(){ //alert('test'); //$("#PageSixbox").slideToggle(); $("#PageFivebox").slideToggle(); $("#PageFourbox").slideToggle(); $("#PageThreebox").slideToggle(); //$("#PageTwobox").slideToggle(); $("#PageOnebox").slideToggle(); } </script> <!--- LOCALIZED COPY OF JAVASCRIPT --> <?php include_once 'css/styleP.css';?> <!--<script src="https://code.jquery.com/jquery-3.2.1.min.js"></script> --> <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script> <!--- LOCALIZED COPY OF JAVASCRIPT --> <!--<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>--> <!--<script type="text/javascript" src="https://code.jquery.com/jquery-1.9.1.js"></script> --> <!-- add jquery https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js --> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script> <script type="text/javascript" src="https://code.jquery.com/jquery-3.6.0.js"></script> <script type="text/javascript"> $(document).ready(function(){ //======================================================================================================================================= //======================================================================================================================================= $("#goSearch").click(function(){ var searchString = $("#searchString").val(); //var searchValue= $("input:radio[name=searchValue] :checked").val(); var radioValue = $("input[name='searchValue']:checked").val(); //alert(radioValue); if(searchString==""){ Swal.fire('Invalid Entry. Please try again') exit; } //$("#PageOnebox").slideToggle(); // $("#PageTwobox").slideToggle(); //$("#PageThreebox").slideToggle(); // $("#PageFourbox").slideToggle(); //fVEND $("#PageFivebox").slideToggle(); ShowUploadBar(); $.ajax({ url: "PRF_SearchResults.php", type: "POST", async: false, data: { "radioValue": radioValue, "searchString": searchString, "done": 1 }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#showPRFDashboard").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_DASHBOARD_001.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#ReportList").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_PRF_ReportLists.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#dataAnalytics").click(function(){ ShowUploadBar(); $.ajax({ url: "prf_dataAnalytics.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#forMyApproval").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_NewPRFMyForApproval.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#showMyPurchaseRequest").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_OpenPurchaseRequest.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#showCreateNewPRF").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_CreateNewPRF.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#showDepatPRF").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_DEPTprf.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#procIncomingInfo").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_procIncomingInfo.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#ahgAdminApproval").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_ahgPRFApproval.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#MyForCanvassPRF").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_FORCanvass.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#MyProposals").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_UploadedCanvass.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#CanvassSheet").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_CanvassSheetPreparation.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#forExecomApproval").click(function(){ var chkIfExecom = $("#isEXECOM").val(); //alert(chkIfExecom); if(chkIfExecom == 0) { Swal.fire({ icon: 'error', title: 'Access Denied', text: 'Only the EXECOM members can access this page!' //footer: '<a href="">Why do I have this issue?</a>' }) exit; }else{ ShowUploadBar(); $.ajax({ url: "PRF_EXECOM_APPROVAL.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) } }); //======================================================================================================================================= //======================================================================================================================================= $("#MyUnReadMessage").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_UnreadMessages.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#setupAuthorizingOfficer").click(function(){ ShowUploadBar(); $.ajax({ //url: "PRF_SETUP_AssetValidator.php", PRF_SETUPAssetValidatorV2.php url: "PRF_SETUPAssetValidatorV2.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#setupGMOfficer").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_SETUPGMBYCompany.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#setupEXECOMOfficerS").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_SETUP_EXECOM.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#readyForPOCreation").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_ReadyForPO.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#activePO").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_ACTIVE_PO.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#readyForPOApproval").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_POFORAPPROVAL.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#readyForPOSubmission").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_POFORSUBMISSIONTOVENDOR.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#suppliersUpdate").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_ACTIVESUPPLIERSPO.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#forPayment").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_FORPAYMENT.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= $("#poApprover").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_SETUPPOApprover.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= $("#itemMasterFile").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_SetupItemClass.php", //PRF_CANVASS_FOR_USR_APPROVAL usrCanvassApproval type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= $("#UpdateMatrix").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_updateMatrixTable.php", //PRF_CANVASS_FOR_USR_APPROVAL usrCanvassApproval type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= $("#vendorManagement").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_Vendors.php", //PRF_CANVASS_FOR_USR_APPROVAL usrCanvassApproval type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= $("#usrCanvassApproval").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_CANVASSFORUSRAPPROVAL.php", //PRF_CANVASS_FOR_USR_APPROVAL usrCanvassApproval type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= $("#MatrixONButton").click(function(){ var update ='OFF'; //alert(update); Swal.fire({ title: 'Do you want to save the changes?', showDenyButton: false, showCancelButton: true, confirmButtonText: 'DeActivate', denyButtonText: `Don't Activate`, }).then((result) => { /* Read more about isConfirmed, isDenied below / if (result.isConfirmed) { Swal.fire('Saved!', '', 'success') //if(confirm("CONFIRM ACTION: \n\nAre you sure you want to route ALL CANVASS APPROVAL TO EXEOM ONLY. If you proceed, the APPROVAL MATRIX TABLE will NOT be used. \n\n Press 'OK' button to proceed...")){ ShowUploadBar(); $.ajax({ url: "PRF_updateMatrixKey.php", //PRF_CANVASS_FOR_USR_APPROVAL usrCanvassApproval type: "POST", async: false, data: { "udpate": update, "done": 1 }, success: function(d){ ShowUploadBar(); $("#MatrixONButton").fadeOut(100); $("#MatrixOFFButton").fadeIn(100); $("#mLabelA").html(d); $("#mLabelB").html(d); } }) //} } else if (result.isDenied) { Swal.fire('Changes are not saved', '', 'info') } }) }); //======================================================================================================================================= $("#MatrixOFFButton").click(function(){ var update ='ON'; //alert(update); Swal.fire({ title: 'Do you want to save the changes?', showDenyButton: false, showCancelButton: true, confirmButtonText: 'Activate', denyButtonText: `Don't Activate`, }).then((result) => { / Read more about isConfirmed, isDenied below / if (result.isConfirmed) { Swal.fire('Saved!', '', 'success') //if(confirm("CONFIRM ACTION: \n\nAre you sure you want to route ALL CANVASS APPROVAL TO EXEOM ONLY. If you proceed, the APPROVAL MATRIX TABLE will NOT be used. \n\n Press 'OK' button to proceed...")){ ShowUploadBar(); $.ajax({ url: "PRF_updateMatrixKey.php", //PRF_CANVASS_FOR_USR_APPROVAL usrCanvassApproval type: "POST", async: false, data: { "udpate": update, "done": 1 }, success: function(d){ ShowUploadBar(); $("#MatrixONButton").fadeIn(100); $("#MatrixOFFButton").fadeOut(100); $("#mLabelA").html(d); $("#mLabelB").html(d); } }) //} } else if (result.isDenied) { Swal.fire('Changes are not saved', '', 'info') } }) }); }); //================== // $("#HideShowMenu").click(function(){ // $("#displayMenu").animate({width: 'toggle'}); //}); //==================== //var isOn = true; //$(function(){ // $("#HideShowMenu").click(function(){ // console.log(isOn); // if ( isOn ){ // isOn = false; // $('.BodyArea').css("width", '100%'); // // } else { // isOn = true; // $('.BodyArea').css("width", '80%'); // // } // return false; // }); //}); </script> <!-- MENU SLIDING SCRIPT --> <script src="https://code.jquery.com/jquery-3.5.1.min.js"></script> <script> $(document).ready(function(){ $("#PageOne").click(function(){ $("#PageOnebox").slideToggle(); }); }); $(document).ready(function(){ $("#PageTwo").click(function(){ $("#PageTwobox").slideToggle(); }); }); $(document).ready(function(){ $("#PageThree").click(function(){ $("#PageThreebox").slideToggle(); }); }); $(document).ready(function(){ $("#PageFour").click(function(){ $("#PageFourbox").slideToggle(); }); }); $(document).ready(function(){ $("#PageTwoB").click(function(){ $("#PageTwoBbox").slideToggle(); }); }); $(document).ready(function(){ $("#PageFive").click(function(){ $("#PageFivebox").slideToggle(); }); }); $(document).ready(function(){ $("#PageSix").click(function(){ $("#PageSixbox").slideToggle(); }); }); function ShowUploadBar() { var div = document.getElementById("loadBaraData"); if (div.style.display == 'none') { div.style.display = ''; } else { div.style.display = 'none' } } </script> </head> <body style="font-family:Verdana;color:#aaaaaa;background:white"> <!--#########################################################################--> <!--#########################################################################--> <input type="hidden" id="passCompID" value="<?php echo $comID;?>"> <input type="hidden" id="passUID" value="<?php echo $userID;?>"> <!--<div style="width:100%;height:50px;padding:8px;border-bottom:1px solid #2c3e29" class="grayBG"> <div id='myDashboard'style='float:left;margin:4px;margin-left:0px;left:-20px;position:relative'><a href="connect.php" class="active" style="font-family:Calibri;font-size:18px;padding:12px;color:white;font-weight:bold;padding-right:30px;padding-right:80px;margin-left:0px;margin:2px">⇚     🌐HOME</a> </div> <div style='width:500px;float:left;margin:5px;background:transparent;margin-top:0px'><a href="#" style="float:left;font-family:Calibri;font-size:24px;font-weight:bold;color: #02133d;margin-top:0px">PROCUREMENT MANAGEMENT SYSTEM:</a></div> </div> --> <a href='#' id='HideShowMenu' style='display:none;float:left;font-family:Calibri;font-size:24px;font-weight:bold;color: #02133d;margin-top:0px'><div style='float:left;width:40px;height:40px;z-index:99999;position:absolute;margin-top:0px;margin-left:0px;border:1px solid black;border-radius:0px 10px 10px 0px;background:black;font-family:Calibri;color:white'> ◀ </div></a> <div id="displayMenu" class="subMenu" style='background:#fbfbf9'> <?php $unPostedPRFRequest = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_hdr` WHERE `request_by` ='$userID' AND `current_status`= '100' AND `deleted`=0 \|\| `request_by` ='$userID' AND `current_status`= '0' AND `deleted`=0"),0); $PostedPRFRequest = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_hdr` WHERE `request_by` ='$userID' AND `current_status` > 0 AND `current_status` < 13 AND `deleted` = 0"),0); //$userCanvassApproval= mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `request_by` ='$userID' AND `current_status`=5 AND `deleted` = 0"),0); 1024008751 $getItemUsrApproval = mysql_query("SELECT FROM `prf_request_hdr` WHERE `request_by` ='$userID' AND `deleted` = 0 AND `current_status` = 5 ORDER BY id DESC"); while($row=mysql_fetch_array($getItemUsrApproval)){ $chkIfForUSRApproval=$row['user_canvass_approval']; $hdrRefCode = $row['reference_code']; $getMyuserApproval = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_request_detl` WHERE `header_ref_code`='$hdrRefCode' AND `user_canvass_approval`= 1 AND `user_approval_ts`='' AND `create_canvass_sheet`= '0' AND `deleted`=0"),0); $userCanvassApproval = $userCanvassApproval + $getMyuserApproval; } //echo $userCanvassApproval; if($userCanvassApproval == ''){ $userCanvassApproval = '0'; } $PostedForDeptApprovalGM = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_hdr` WHERE `approving_GM_id` ='$userID' AND `current_status`!= 0 AND `current_status` < 4 AND `deleted` = 0 AND `gm_approval_date`='' AND `dept_approval_date`!='' AND `admin_approval_date`!=''"),0); $PostedForDeptApprovalHead = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_hdr` WHERE `dept_head_id` ='$userID' AND `current_status`!= 0 AND `current_status` < 4 AND `deleted` = 0 AND `dept_approval_date`='' "),0); $PostedForDeptApprovalAdmin = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_hdr` WHERE `approving_admin_id` ='$userID' AND `current_status`!= 0 AND `current_status` < 4 AND `deleted` = 0 AND `admin_approval_date`='' AND `dept_approval_date`!='' AND `gm_approval_date`!=''"),0); $PostedForDeptApproval = $PostedForDeptApprovalHead + $PostedForDeptApprovalGM + $PostedForDeptApprovalAdmin; $ActiveProposal = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_uploadedcanvass` WHERE `deleted`= 0 AND `validity_date` > '$toDate'"),0); $procIncomingView = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_hdr` WHERE `current_status` < 4 AND `deleted`=0"),0); $deptPRFCount = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_hdr` WHERE `dept_id` '$MyDeptID' AND `deleted`=0"),0); /* $getItemHdr = mysql_query("SELECT * FROM `prf_request_detl` WHERE `deleted`=0 AND `served`='0' AND `awarded` = 0 AND `award_to_vendor_id` = 0 AND `user_canvass_approval`=0 AND `for_execom_canvass_approval`=0 AND `for_canvass` = 1 ORDER BY id DESC"); while($row=mysql_fetch_array($getItemHdr)){ $itemRefCode=$row['header_ref_code']; $getPRFApprovalCode = mysql_result(mysql_query("SELECT current_status FROM prf_request_hdr WHERE reference_code='$itemRefCode' "),0); if($getPRFApprovalCode == 4){ $forCanvassCount = $forCanvassCount + 1; } } / $ahgAdminApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_hdr` WHERE `deleted`=0 AND `ahg_admin_id`=0 AND `ahg_admin_date`='' AND `gm_approval_date`!='' AND `dept_approval_date`!='' AND `admin_approval_date`!=''"),0); $forCanvassCount = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `deleted`=0 AND `served`='0' AND `awarded` = 0 AND `for_canvass` = 1 AND `award_to_vendor_id` = 0 AND `user_canvass_approval`=0 AND `ahg_admin_id`!=0 AND `ahg_admin_date`!='' AND `ahg_admin_id`!=0 AND `ahg_admin_date`!='' ORDER BY id DESC"),0); if($forCanvassCount == ''){ $forCanvassCount = 0; } $MyCanvassSheet = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `create_canvass_sheet`= 1 AND `deleted`=0 AND `awarded`='0' AND `create_canvass_sheet`= 1 AND `for_execom_canvass_approval`=0 AND `canvass_sheet_creation_ts`=''"),0); $chkMyOpenMessage = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_ff_message` WHERE `read`= 1 AND `deleted`=0 AND `send_to`='$userID'"),0); $PostedExeComApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `for_execom_canvass_approval`=1 AND `canvass_sheet_creation_ts`!='' AND `execom_approval_ts`='' AND `awarded`=0"),0); $ReadyForPO = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `awarded`= 1 AND `deleted`=0 AND `execom_approval_ts`!= '' AND `for_execom_canvass_approval`=1 AND `po_code`=''"),0); $POApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_purchase_order` WHERE `po_status` = 2"),0); $ActivePO = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_purchase_order` WHERE `po_status`= 1"),0); $forPaymentPO = mysql_result(mysql_query("SELECT COUNT(1) FROM (SELECT FROM `prf_delivery_receiving_logs` WHERE `inv_status`='Unpaid' GROUP BY `inv_number`) t1 "),0); $ReadySubmission = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_purchase_order` WHERE `po_status`= 3"),0); $vendorsUpdate = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_purchase_order` WHERE `po_status`= 4"),0); echo "<button type='button' id='PageSix' class='menuTitle' >🔎    SEARCH</button> <div id='PageSixbox' style='border:0px;margin:0px;padding:0px'>"; echo "<div class='menuItem' style='height:200px'>"; echo "<input type='text' id='searchString' style='font-size:18px;text-align:center;border-radius:5px;border:1px solid gray;padding:10px;font-family:Calibri;font-size:16px;color:black;width:100%'>"; echo "<input type='radio' id='PRFNumber' name='searchValue' value='PRFNumber' checked> <label for='PRFNumber' style='margin:10px;font-family:Calibri;font-size:16px;color:gray;font-weight:normal'>PRF Number</label><br><br> <input type='radio' id='PONumber' name='searchValue' value='PONumber'> <label for='PONumber' style='margin:10px;font-family:Calibri;font-size:16px;color:gray;font-weight:normal'>PO Number</label><br><br>"; echo "<div style='padding:15px;width:100%;'> <button id='goSearch' class='PopUpLowerButtonR' style='width:100%;border-radius:10px'>SEARCH</button> </div>"; echo "</div> "; echo "</div>"; echo "<button type='button' id='PageOne' class='menuTitle' >📊     DASHBOARD</button> <div id='PageOnebox' style='border:0px;margin:0px;padding:0px'> <div id='dataAnalytics' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>💹</div> <div class='pageMenuItemB'>DASHBOARD 1</div> <div class='pagemenuitemC'></div> </div> <div id='showPRFDashboard' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>📉</div> <div class='pageMenuItemB'>DASHBOARD 2</div> <div class='pagemenuitemC'></div> </div> <div id='ReportList' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>📂</div> <div class='pageMenuItemB'>GENERATE REPORTS</div> <div class='pagemenuitemC'></div> </div> </div>"; echo "<button type='button' id='PageTwo' class='menuTitle' >🙎     NAVIGATION MENU</button> <div id='PageTwobox' style='border:0px;margin:0px;padding:0px'> <div id='showCreateNewPRF' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>📝</div> <div class='pageMenuItemB'>CREATE NEW PRF</div> <div class='pagemenuitemC' id='unPostedPRFRequestCount'>".$unPostedPRFRequest."</div> </div> <div id='showMyPurchaseRequest' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>📝</div> <div class='pageMenuItemB'>MY ACTIVE REQUEST</div> <div class='pagemenuitemC' id='PostedPRFRequestCount'>".$PostedPRFRequest."</div> </div> <div id='usrCanvassApproval' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>👷</div> <div class='pageMenuItemB'>USER APPROVAL</div> <div class='pagemenuitemC' id='canvassForUserApprovalCount'>".$userCanvassApproval."</div> </div> <div id='forMyApproval' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>🖌</div> <div class='pageMenuItemB'>FOR MY APPROVAL</div> <div class='pagemenuitemC' id='forMyApprovalCount'>".$PostedForDeptApproval."</div> </div> <div id='forExecomApproval' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>🤵</div> <div class='pageMenuItemB'>EXECOM APPROVAL</div> <div class='pagemenuitemC' id='forExecomApprovalCount'>".$PostedExeComApproval."</div> </div> <div id='MyUnReadMessage' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>📩</div> <div class='pageMenuItemB'>MESSAGE / NOTIFICATION</div> <div class='pagemenuitemC' id='myOpenMessage'>".$chkMyOpenMessage."</div> </div> <div id='showDepatPRF' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>📝</div> <div class='pageMenuItemB'>DEPARTMENT PRF</div> <div class='pagemenuitemC' id='unPostedPRFRequestCount'>".$deptPRFCount."</div> </div> </div>"; //######################################################################################################################################### if($PRFPRO ==1){ echo "<button type='button' id='PageThree' class='menuTitle' >📆     PROCUREMENT MONITORING</button> <div id='PageThreebox' style='border:0px;margin:0px;padding:0px'> <div id='procIncomingInfo' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>📮</div> <div class='pageMenuItemB'>INCOMING REQUEST</div> <div class='pagemenuitemC' id='procIncomingCount'>".$procIncomingView."</div> </div> <div id='ahgAdminApproval' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>📝</div> <div class='pageMenuItemB'>AUTOHUB ADMIN APPROVAL</div> <div class='pagemenuitemC' id='AHGadminApprovalCount'>".$ahgAdminApproval."</div> </div> <div id='MyForCanvassPRF' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>📝</div> <div class='pageMenuItemB'>FOR CANVASS / SOURCING</div> <div class='pagemenuitemC' id='canvassCount'>".$forCanvassCount."</div> </div> <div id='MyProposals' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>🗓</div> <div class='pageMenuItemB'>UPLOAD PROPOSAL</div> <div class='pagemenuitemC' id='ProposalCount'>".$ActiveProposal."</div> </div> <div id='CanvassSheet' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>🗂</div> <div class='pageMenuItemB'>CANVASS SHEET PREPARATION</div> <div class='pagemenuitemC' id='userApprovalCanvassCount'>".$MyCanvassSheet."</div> </div> </div>"; }else{ echo "<button type='button' id='PageThree' class='menuTitle' >📆     PROCUREMENT MONITORING</button> <div id='PageThreebox' style='border:0px;margin:0px;padding:0px'> <div id='procIncomingInfoXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>📮</div> <div class='pageMenuItemBXXX'>INCOMING REQUEST</div> <div class='pagemenuitemCXXX' id='procIncomingCount'>".$procIncomingView."</div> </div> <div id='ahgAdminApprovalXXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>📝</div> <div class='pageMenuItemBXXX'>AUTOHUB ADMIN APPROVAL</div> <div class='pagemenuitemCXXX' id='AHGadminApprovalCount'>".$ahgAdminApproval."</div> </div> <div id='MyForCanvassPRFXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>📝</div> <div class='pageMenuItemBXXX'>FOR CANVASS / SOURCING</div> <div class='pagemenuitemCXXX' id='canvassCount'>".$forCanvassCount."</div> </div> <div id='MyProposalsXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>🗓</div> <div class='pageMenuItemBXXX'>UPLOAD PROPOSAL</div> <div class='pagemenuitemCXXX' id='ProposalCount'>".$ActiveProposal."</div> </div> <div id='CanvassSheetXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>🗂</div> <div class='pageMenuItemBXXX'>CANVASS SHEET PREPARATION</div> <div class='pagemenuitemCXXX' id='userApprovalCanvassCount'>".$MyCanvassSheet."</div> </div> </div>"; } //######################################################################################################################################### //######################################################################################################################################### if($PRFPUR ==1){ echo "<button type='button' id='PageFive' class='menuTitle' >📆     PURCHASE ORDER</button> <div id='PageFivebox' style='border:0px;margin:0px;padding:0px'> <div id='readyForPOCreation' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>🗒</div> <div class='pageMenuItemB'>FOR P.O CREATION</div> <div class='pagemenuitemC' id='forPOCreation'>".$ReadyForPO."</div> </div> <div id='activePO' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>🔄</div> <div class='pageMenuItemB'> P.O VALIDATION</div> <div class='pagemenuitemC' id='forPOValidation'>".$ActivePO."</div> </div> <div id='readyForPOApproval' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>⚠</div> <div class='pageMenuItemB'>FOR P.O APPROVAL</div> <div class='pagemenuitemC' id='forPOApproval'>".$POApproval."</div> </div> <div id='readyForPOSubmission' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>✅</div> <div class='pageMenuItemB'>FOR SUBMISSION TO VENDOR</div> <div class='pagemenuitemC' id='forPOSubmission'>".$ReadySubmission."</div> </div> <div id='suppliersUpdate' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>♻</div> <div class='pageMenuItemB'>ACTIVE PO (SUPPLIER)</div> <div class='pagemenuitemC' id='POSupplierCount'>".$vendorsUpdate."</div> </div> <div id='forPayment' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>🚚</div> <div class='pageMenuItemB'>FOR PAYMENT</div> <div class='pagemenuitemC'id='POForPayment'>".$forPaymentPO."</div> </div> </div>"; }else{ echo "<button type='button' id='PageFive' class='menuTitle' >📆     PURCHASE ORDER</button> <div id='PageFivebox' style='border:0px;margin:0px;padding:0px'> <div id='readyForPOCreationXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>🗒</div> <div class='pageMenuItemBXXX'>FOR P.O CREATION</div> <div class='pagemenuitemCXXX' id='forPOCreation'>".$ReadyForPO."</div> </div> <div id='activePOXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>🔄</div> <div class='pageMenuItemBXXX'> P.O VALIDATION</div> <div class='pagemenuitemCXXX' id='forPOCreation'>".$ActivePO."</div> </div> <div id='readyForPOApprovalXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>⚠</div> <div class='pageMenuItemBXXX'>FOR P.O APPROVAL</div> <div class='pagemenuitemCXXX' id='forPOCreation'>".$POApproval."</div> </div> <div id='readyForPOSubmissionXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>✅</div> <div class='pageMenuItemBXXX'>FOR SUBMISSION TO VENDOR</div> <div class='pagemenuitemCXXX' id='forPOCreation'>".$ReadySubmission."</div> </div> <div id='suppliersUpdateXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>♻</div> <div class='pageMenuItemBXXX'>ACTIVE PO (SUPPLIER)</div> <div class='pagemenuitemCXXX' id='POSupplierCount'>".$vendorsUpdate."</div> </div> <div id='forPaymentXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>🚚</div> <div class='pageMenuItemBXXX'>FOR PAYMENT</div> <div class='pagemenuitemCXXX'id='POForPayment'>".$forPaymentPO."</div> </div> </div>"; } //######################################################################################################################################### $getMatrixSetup = mysql_result(mysql_query("SELECT `matrix_on_off` FROM `asa_versioning_db` WHERE 1 "),0); if($getMatrixSetup ==='OFF'){ $matrixOn ='none'; $matrixOff ='block'; $mColor='red'; } else{ $matrixOn ='block'; $matrixOff ='none'; $mColor='green'; } //######################################################################################################################################### if($PRFSET ==1){ echo "<button type='button' id='PageFour' class='menuTitle' >⚙     SETUP</button> <div id='PageFourbox' style='border:0px;margin:0px;padding:0px'>"; if($ITMASTER ==1){ echo "<div id='itemMasterFile' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>📦</div> <div class='pageMenuItemB'>ITEM MASTERFILE</div> <div class='pagemenuitemC'>"; echo "</div> </div> "; echo "<div id='setupAuthorizingOfficer' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>🪤</div> <div class='pageMenuItemB'>ASSET VALIDATOR</div> <div class='pagemenuitemC'> </div> </div> <div id='setupGMOfficer' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>🤵</div> <div class='pageMenuItemB'>COMPANY GEN. MANAGER</div> <div class='pagemenuitemC'> </div> </div> <div id='setupEXECOMOfficerS' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>🤴</div> <div class='pageMenuItemB'>EXECOM/AVP/SVP APPROVER</div> <div class='pagemenuitemC'></div> </div> <div id='poApprover' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>📜</div> <div class='pageMenuItemB'>P.O APPROVER</div> <div class='pagemenuitemC'></div> </div>"; }else{ echo "<div id='UpdateMatrixXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>🏷</div> <div class='pageMenuItemBXXX'>ITEM MASTERFILE</div> <div class='pagemenuitemCXXX'>"; echo "</div> </div> "; echo "<div id='setupAuthorizingOfficerXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>🪤</div> <div class='pageMenuItemBXXX'>ASSET VALIDATOR</div> <div class='pagemenuitemCXXX'> </div> </div> <div id='setupGMOfficerXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>🤵</div> <div class='pageMenuItemBXXX'>COMPANY GEN. MANAGER</div> <div class='pagemenuitemCXXX'> </div> </div> <div id='setupEXECOMOfficerSXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>🤴</div> <div class='pageMenuItemBXXX'>EXECOM/AVP/SVP APPROVER</div> <div class='pagemenuitemCXXX'></div> </div> <div id='poApproverXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>📜</div> <div class='pageMenuItemBXXX'>P.O APPROVER</div> <div class='pagemenuitemCXXX'></div> </div>"; } echo "<div id='vendorManagement' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>📠</div> <div class='pageMenuItemB'>MANAGE VENDORS/SUPPLIERS</div> <div class='pagemenuitemC'></div> </div>"; if($MATRIX ==1){ echo "<div id='UpdateMatrix' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>🏷</div> <div class='pageMenuItemB'>UPDATE APPROVAL MATRIX </div> <div class='pagemenuitemC'>"; echo "</div> </div> "; }else{ echo "<div id='UpdateMatrixXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>🏷</div> <div class='pageMenuItemBXXX'>UPDATE APPROVAL MATRIX </div> <div class='pagemenuitemCXXX'>"; echo "</div> </div> "; } if($MATRIX ==1){ echo "<div id='setMatrixOnOff' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>☎</div> <div class='pageMenuItemB' id='mLabelA'>APPROVAL MATRIX ( <b style='font-weight:bold;color:$mColor'>".$getMatrixSetup."</b> )</div> <div class='pagemenuitemC'>"; echo "<div style='width:100%;border:1px solid #3e3d3d ;background: #dbd5d4 ;height:16px;border-radius:10px;'> <button id='MatrixOFFButton' style='cursor:pointer;width:40%;height:12px;margin:1px;background:red;float:left;display:$matrixOff;border-radius:5px;'></button> <button id='MatrixONButton'style='cursor:pointer;width:40%;height:12px;margin:1px;background:green;float:right;display:$matrixOn;border-radius:5px;'></button> </div>"; echo "</div> </div> "; }else{ echo "<div id='setMatrixOnOffXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>☎</div> <div class='pageMenuItemBXXX' id='mLabelB'>APPROVAL MATRIX ( <b style='font-weight:bold;color:$mColor'>".$getMatrixSetup."</b> )</div> <div class='pagemenuitemCXXX'>"; echo "<div style='width:100%;border:1px solid #3e3d3d ;background: #dbd5d4 ;height:16px;border-radius:10px;'> <button id='MatrixOFFButtonXXX' style='cursor:pointer;width:45%;height:12px;margin:1px;background: #afaead;float:left;display:$matrixOff;border-radius:5px;'></button> <button id='MatrixONButtonXXX'style='cursor:pointer;width:45%;height:12px;margin:1px;background:gray;float:right;display:$matrixOn;border-radius:5px;'></button> </div>"; echo "</div> </div> "; } echo "</div>"; } //######################################################################################################################################### ?> </div> <div id="cleranceTemplateView" class="bodyArea"> <?php include_once 'PRF_DASHBOARD_001.php';?> </div> <!--<div style="text-align:center;float:left;width:100%;height:auto;margin:0px;border:0px solid red;padding:0px;background:black"> <?php //include 'footer.php';?> </div> --> </body> </html> <!--https://unicode-table.com/en/emoji/#link-objects--> PK��Z<�g�ry��ry��PRF_ACTIVE_PO.phpnu��[��PK��Z�q/i��/i��y��connect.phpnu��[��PK��Z�w<7��PRF_procurement_page.phpnu��[��PK��

| ver. 1.4 | . | PHP 8.1.32 | Generation time: 0 | proxy | phpinfo | Settings